Name |
|
Code |
|
Comment |
|
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(80) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(12) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
CLOB |
Mandatory |
No |
Comment |
Lista idetyfikatorów grup uzytkowników, do których ma byc wyslana wiadomosc |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
CLOB |
Mandatory |
No |
Comment |
przechowuje informacyjnie identyfikatory typów uzytkownika oddzielone przecinkiem, którym nalezy wyslac powiadomienie. |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
CLOB |
Mandatory |
No |
Comment |
Zmienne (w formacie json), wykorzystywane do tworzenia docelowej wiadomosci na bazie szablonu |
Name |
|
Code |
|
Data Type |
VARCHAR2(64) |
Mandatory |
No |
Comment |
Kolumna ta pozwala na zabezpieczenie sie przed powtórnym wyslaniem tej samej wiadomosci. |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID encji, której dotyczy powiadomienie |
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|